import pandas as pd

excel = pd.read_excel(r'C:\Users\Administrator\Desktop\test_blank.xlsx',sheet_name=None)


#读取表中的所有数据,把它们转换成html
html = {}

for key in excel.keys():
    html[key] = excel[key].to_html(columns = [])

print(html['Sheet4'])